<?php
	require_once("../connectMysql/connetMysql.class.php"); 
	$db=new connetMysql;
	$con=$db->getConnect();
	$chk_sql="SELECT ActivityId,DATE_FORMAT(ActPublish, '%y-%m-%d'),ActDescri,ActStatus FROM activity  order by ActivityId desc";	
	$result=$con->query($chk_sql);
	while ($row = mysqli_fetch_assoc($result))
	{
		$arr[] = array( 
		'actTitle'=>$row['ActDescri'], 
		'actId'=>$row['ActivityId'],
		'actStatus'=>$row['ActStatus'],
		'actPublish'=>$row["DATE_FORMAT(ActPublish, '%y-%m-%d')"]		
		 ); 
	}
	echo json_encode($arr); 
	$con->close(); 
							
?>